NextIsNull (fld)

Basic and Crystal syntax.

Arguments

fld is any valid database, formula, memo or BLOB field in the report.

Returns

Boolean Value

Action

Evaluates the field specified in the next record and returns TRUE if the field contains a null value.

Typical uses

You can use this function to test for the last item in a list and to take some action when you identify that last item.

Examples

The following example is applicable to Crystal syntax:

If NextIsNull ({employee.EMPLOYEE ID}) Then

    "Last employee of record"

Else

    ""

In an employee database with no null values in the Employee ID field, flags the last employee on the list.

Comments

Some databases support null data values and others do not. This function will not work if the active database(s) do not support null values. If the database(s) do support null values, the function can be used to reference the null values that get created as the result of a failed lookup while joining.

Note:    



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com